<?php
require_once (dirname(__FILE__)."/../config/config.php");
?>
<?php 
	if($_REQUEST['method']=='addNbnOrder'){
	$orderNo=$_REQUEST['orderNo'];
	$phone_connection=$_REQUEST['phone_connection'];
	$phone_number=$_REQUEST['phone_number'];
	$contract=$_REQUEST['contract'];
	$need_modem=$_REQUEST['need_modem'];
	$phone_line_rental=$_REQUEST['phone_line_rental'];
	$installation=$_REQUEST['installation'];
	$eset_security=$_REQUEST['eset_security'];
	$home_phone_handset=$_REQUEST['home_phone_handset'];
	$modem_data_offer=$_REQUEST['modem_data_offer'];
	$title=$_REQUEST['title'];
	$first_name=$_REQUEST['first_name'];
	$last_name=$_REQUEST['last_name'];
	$birthdate=$_REQUEST['birthdate'];
	$account=$_REQUEST['account'];
	$account_text=$_REQUEST['account_text'];
	$phone=$_REQUEST['phone'];
	$mobile=$_REQUEST['mobile'];
	$email=$_REQUEST['email'];
	$confirmEmail=$_REQUEST['confirmEmail'];
	$delivery_radio=$_REQUEST['delivery_radio'];
	$street_number=$_REQUEST['street_number'];
	$street_name=$_REQUEST['street_name'];
	$suburb=$_REQUEST['suburb'];
	$type_state=$_REQUEST['type_state'];
	$postcode=$_REQUEST['postcode'];
	$pay_method=$_REQUEST['pay_method'];
	$card_type=$_REQUEST['card_type'];
	$card_name=$_REQUEST['card_name'];
	$card_number=$_REQUEST['card_number'];
	$card_type_month=$_REQUEST['card_type_month'];
	$card_type_year=$_REQUEST['card_type_year'];
	$cvv2=$_REQUEST['cvv2'];
	$account_name=$_REQUEST['account_name'];
	$account_number=$_REQUEST['account_number'];
	$bsb=$_REQUEST['bsb'];
	$overseacalls=$_REQUEST['overseacalls'];
	$smartTV=$_REQUEST['smartTV'];
	$customer_source=$_REQUEST['customer_source'];
	$order_status=$_REQUEST['order_status'];
	$setup_fee=$_REQUEST['setup_fee'];
	$phone_transfer_fee=$_REQUEST['phone_transfer_fee'];
	$modem_fee=$_REQUEST['modem_fee'];
	$month_fee=$_REQUEST['month_fee'];
	$delivery_fee=$_REQUEST['delivery_fee'];
	$installation_fee=$_REQUEST['installation_fee'];
	$eset_security_fee=$_REQUEST['eset_security_fee'];
	$home_phone_handset_fee=$_REQUEST['home_phone_handset_fee'];
	$modem_data_offer_fee=$_REQUEST['modem_data_offer_fee'];
	$international_calls_fee=$_REQUEST['international_calls_fee'];
	$smart_tv_fee=$_REQUEST['smart_tv_fee'];
	$create_time=date("Y-m-d H:i:s");
	$referral_id = $_REQUEST['referral_id'];
	$sqlorderinsert="insert into zy_nbnorder(orderNo,phone_connection,phone_number,contract,need_modem,phone_line_rental,installation,eset_security,home_phone_handset,modem_data_offer,title,first_name,last_name,birthdate,account,account_text,phone,mobile,email,confirmEmail,delivery_radio,street_number,street_name,suburb,type_state,postcode,pay_method,card_type,card_name,card_number,card_type_month,card_type_year,cvv2,account_name,account_number,bsb,overseacalls,smartTV,customer_source,order_status,setup_fee,phone_transfer_fee,modem_fee,month_fee,delivery_fee,installation_fee,eset_security_fee,home_phone_handset_fee,modem_data_offer_fee,international_calls_fee,smart_tv_fee,create_time,referral_id) value ('$orderNo','$phone_connection','$phone_number','$contract','$need_modem','$phone_line_rental','$installation','$eset_security','$home_phone_handset','$modem_data_offer','$title','$first_name','$last_name','$birthdate','$account','$account_text','$phone','$mobile','$email','$confirmEmail','$delivery_radio','$street_number','$street_name','$suburb','$type_state','$postcode','$pay_method','$card_type','$card_name','$card_number','$card_type_month','$card_type_year','$cvv2','$account_name','$account_number','$bsb','$overseacalls','$smartTV','$customer_source',$order_status,'$setup_fee','$phone_transfer_fee','$modem_fee','$month_fee','$delivery_fee','$installation_fee','$eset_security_fee','$home_phone_handset_fee','$modem_data_offer_fee','$international_calls_fee','$smart_tv_fee','$create_time','$referral_id')";
	mysql_query($sqlorderinsert);
	echo 'success';
	}
?>